package com.example.doctorstation.POJOMapper;

import com.example.doctorstation.POJOData.UserRole;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Victoria-Al
 * @date 2021-05-06
 * 描述： 角色类持久层
 **/
@Mapper
public interface RoleMapper {
    @Select("select role.roleId, role.roleName, role.EMREditorModeID from config_user user, config_role role, config_user_role ur where user.userId = ur.userId and role.roleId = ur.roleId and user.userId = #{userId}")
    List<UserRole> findByUserId(int UserId);

}
